Search form design / Dialog designer

You can configure the display of multiple controls at the same time by drawing a marquee around the selected items with your mouse. Press and hold the mouse key down and draw a box around the controls you want to edit.

• Any item contained within the marquee will move as a group when one of them is selected and click-dragged
• The last item clicked becomes the "Primary" selected item. The "Primary" selected item has a red outline, while other selected items have a bold/black outline
• To 'nudge' selected items in a direction, hold the Alt key and press an arrow key. The selected items will move one grid position (3x3) in the direction pressed. If the primary item is not aligned with the 3x3 grid, it will 'snap' into position before moving. All selected items will keep their relative positions to the primary control
• To align selected items with the primary control, hold Alt and Shift, then press an arrow key. The arrow key pressed corresponds to the side that the items will align themselves to. (e.g. Alt+Shift+Right will move all selected items so that their right side is at the same x position as that of the primary selected item)
• Holding Ctrl and clicking on an unselected item will select it - and vice versa. Holding Ctrl and click-dragging to draw a marquee will also have this effect on the items the marquee surrounds
• To resize, click and drag on one of the "dots" around the primary selected item. Much like in Microsoft Office programs, click-dragging a dot resizes the sides perpendicular to the side clicked of the item. The diagonal dot allows for resizing both the width and height. esizing will be applied to all selected objects as a flat increase/decrease. (i.e. dragging the dot a distance of 'x' pixels will increase the size of all selected items by 'x' pixels, regardless of the item's original size)
• Click+dragging after having drawn a marquee will clear the selection and begin drawing a new marquee, rather than having to click twice to perform those actions separately
• Removing selected items or altering their dimensions/position with the 'control details' moves/removes the highlight
• Selecting items in the listbox will clear the selection and then select/highlight the corresponding item

Reference: text(20), mandatory

This is the name given to the control. This name is used to identify the control and, when used in the SQL query or in the selection criteria specified for the control (if applicable), will be substituted with the actual data represented by the control when the Search is executed.

Reference: text(255)

Information is under review for a new version and will be updated soon.

Reference: select from list

Information is under review for a new version and will be updated soon.

This field is only available for text box, check box, combo box, check list, and option control types.

Reference: select from list

This is the alignment of the control. Users can select between left, right and centred.

This field is only available for text box, label, check box, and option control types.

Reference: select from list, mandatory

This represents the type of data the search expects to find in this field. Since SQL treats data differently within an SQL command, searches need to know the type of data so it can be formatted to give correct results when used in the query. There are five options available as follows:

• <None>: If no data is expected from a control, using this option will ensure that no data is read from the control 
• Text: This option should be used when the user is entering text
• Number: When the user is expected to enter numerical values, select this option. This option should always be used in conjunction with check lists
• Date: This indicates that the data entered by the user represents a valid date.
• True / False: If the data is of the true / false or Yes/no type, select this option. This option should always be used in conjunction with Check boxes

Reference: number, mandatory

This specifies the left position (in screen pixels from the edge of the dialog) of the selected control.

Reference: number, mandatory

This specifies the top position (in screen pixels from the bottom of the description panel) of the selected control.

Reference: number, mandatory

This specifies the width (in screen pixels) of the selected control.

Reference: number

This specifies the height (in screen pixels) of the selected control. Combo box controls have a fixed height, so adjusting the height value for a combo box will have no visual effect. Check list heights occur in fixed steps, so their height needs to be adjusting by a certain amount before it will have a visual effect.

Reference: text(50)

Information is under review for a new version and will be updated soon.

This field is only available for text box, check box, combo box, and option control types.

Reference: Yes/no

Information is under review for a new version and will be updated soon.

This field is only available for the check list control type.

Reference: memo

Information is under review for a new version and will be updated soon.

This field is only available for text box and label control types.

Reference: Yes/no

Information is under review for a new version and will be updated soon.

This field is only available for the text box control type.

Reference: memo, mandatory

This option is only available in for the combo box and check list controls, and specifies the location of the data to fill the control.

This field can either specify a database table or an SQL query beginning with the keyword SELECT. If the text entered here does not begin with the word SELECT, it is assumed to be the name of a database table.

Reference: memo, mandatory

This option is only available for the combo box and check list controls, and specifies the field name of the selected data that should be used to display each entry in the combo box or check list. This name must match either the name of a database table field or the field name selected from the SQL query as appropriate.

Reference: memo, mandatory

This option is only available for the combo box and check list controls, and specifies the field name of the selected data that will be used as a substitution for the control name when the query is executed. This name must match either the name of a database table field or the field name selected from the SQL query as appropriate.

Reference: memo

Information is under review for a new version and will be updated soon.

Reference: memo

The Selection criteria field plays a vital role in limiting data that is returned by a search. This field is only relevant when the Search or Report is being executed AND the selected control has data entered into it or selected for it.

If the dialog designer relates to a Search, then the text entered specifies an additional SQL expression that will be ANDed to the existing WHERE clause in the current SQL query designed for the search. The name of the control can be used and will be substituted with the data that was entered by the user formatted correctly for an SQL query.

If the dialog designer relates to a Report, then the text entered specifies an additional selection criterion that will be passed in to the relevant Report.

Reference: Yes/no

This specifies that the Search should be refreshed immediately when the data for the control is changed by the user. If this option is not set, the user must click on the Search dialog’s Refresh button to refresh the search using the new data.

Care should be taken using this option with a text field if the resultant search is likely to take a long time as the search will be refreshed after each key press.

Reference: Yes/no

This specifies that a value is required to be entered in the field before the search can be conducted. If no value has been entered, the user will be warned and the search will not be conducted.

This field is only available for text box, label, combo box, and check list control types. It is only available in check list when the Single selection box is checked.